<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
//公司信息表
class CreateCompanyInfosTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('company_infos', function (Blueprint $table) {
            $table->increments('id');
            $table->timestamps();
            $table->integer('uid');//用户id
            $table->string('logo',255);//公司logo
            $table->string('cname',50);//公司名称
            $table->string('hangye',50);//公司行业
            $table->string('renshu',50);//公司人数规模
            $table->string('xingzhi',50);//公司性质
            $table->string('jianjie',2000);//公司简介
            $table->string('province',20)->nullable();//省
            $table->string('city',20)->nullable();//市
            $table->string('area',20)->nullable();//区
            $table->string('detailed_address')->nullable();//详细地址
            $table->string('image',1000)->nullable();//公司图片
            $table->string('video')->nullable();//公司视频
            $table->string('music')->nullable();//公司音频
            $table->string('phone',20)->nullable();//联系电话
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('company_infos');
    }
}
